CREATE TABLE [dbo].[TTCOAC_DETR]
(
[CO_ACTI_DETR] [dbo].[TD_VC_003] NOT NULL,
[DE_ACTI_DETR] [dbo].[TD_VC_100] NOT NULL,
[PO_DETR] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TTCOAC_DE__PO_DE__26CFC035] DEFAULT ((0)),
[IM_MINI_DETR] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TTCOAC_DE__IM_MI__28B808A7] DEFAULT ((0)),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTCOAC_DE__FE_US__2AA05119] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTCOAC_DE__FE_US__2B947552] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTCOAC_DETR] ADD CONSTRAINT [CK__TTCOAC_DE__IM_MI__29AC2CE0] CHECK (([IM_MINI_DETR]>=(0)))
GO
ALTER TABLE [dbo].[TTCOAC_DETR] ADD CONSTRAINT [CK__TTCOAC_DE__PO_DE__27C3E46E] CHECK (([PO_DETR]>=(0)))
GO
ALTER TABLE [dbo].[TTCOAC_DETR] ADD CONSTRAINT [PK_TTCOAC_DETR] PRIMARY KEY CLUSTERED  ([CO_ACTI_DETR]) ON [PRIMARY]
GO
